package com.kevin.session;

import java.io.Closeable;

import com.kevin.action.JdbcParams;
import com.kevin.table.MDataTable;

public interface SqlSession extends Closeable{
	MDataTable select(Integer pageIndex, Integer pageSize);	
	
	MDataTable select(Integer pageIndex, Integer pageSize, String where);	
	
	MDataTable select(Integer pageIndex, Integer pageSize, String where,JdbcParams[] paramList);	
	
	MDataTable select(Integer pageIndex, Integer pageSize,String... columns);	
	
	MDataTable select(Integer pageIndex, Integer pageSize, String where,String... columns);	
	
	MDataTable select(Integer pageIndex, Integer pageSize, String where,JdbcParams[] paramList,String... columns);	
		
	int count(String where);
		
	int count(String where,JdbcParams... paramList);
	
	int insert(MDataTable table);
	
	int update(MDataTable table);
	
	int update(MDataTable table,String where);
	
	boolean delete(String where);
		
	MDataTable newDataTable();
	
}
